{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Instructions","Lookup","DataEntry","StockSolutionsHELP","Calculate","JarG","Neat chemical help","Calibrate Data","JarSettingsHELP","HydraulicMixHELP","NozzleMixHELP","TurbineMixHELP","PaddleMixHELP","BeamMixHELP","Database"],"not_rendered":{"charts":14,"images":9,"macros":1,"external_links":0,"defined_names":48,"comments":10,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":60,"n_cols":3,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Jar Test Program"]
["Instructions"]
["Enter Data:"]
["  Enter jar test data into the DataEntry worksheet."]
["  The StockSolutionHELP worksheet provides information on making stock solutions."]
["  The JarSettingsHELP worksheet provides information on setting mixing speeds and settling times."]
["  The results from individual jar tests can be saved to the Database worksheet by clicking on the Updata Database Button"]
["    found in the DataEntry worksheet."]
["  Results from a previous jar test can be retrieved from the database by inputting the jar test date and number and clicking"]
["    on the Retrieve Button found in the DataEntry worksheet."]
[]
[]
[null,{"$f":"A1","v":"Jar Test Program"}]
[null,"FILE:","JarTest39.xlsM"]
[null,"AUTHORS:","L. DeMers, K. Rakness, and B. Hegg"]
[null,"COMPANY:","Process Applications, Inc."]
[null,"PURPOSE:","Spreadsheet to support jar testing"]
[null,"CONTRIBUTORS:  J. Schulze (TNRCC), J. Roney (KYDOW), J. Williams (LDHH)"]
[]
["DATE MODIFIED:",null,"MODIFICATIONS & BY WHOM:"]
["1998-07-15","LDD developed program for Franklin CTA."]
["1999-07-20","LDD added comments for data entry cells"]
["1999-07-27","LDD modified per use at TNRCC IT session (corrected error in polymer aid calc, modified chart)"]
[null,"Worksheet is protected except for data entry cells.  Worksheet can be unprotected to modify."]
["1999-08-02","LDD added calculation of jar RPM based on water temperature and desired G value."]
["2000-06-12","KLR added macro to update database and retrieve data from the database."]
["2000-06-19","LDD modified settling time calcs to consider rectangular and circular basin configurations."]
["2001-05-25","LDD added worksheets to calculation velocity gradients for different types of mixers."]
["2001-07-20","LDD modified settling time calcs based on settling velocity with and without tube settlers."]
["2001-08-15","LDD added velocity gradient calculations for walking beam flocculator."]
["2001-09-19","LDD added rapid mix velocity gradient input and HELP buttons for mixing worksheets."]
["2001-12-04","LDD corrected error in rpm calculation based on input G value."]
["2002-01-14","LDD added flexibility to use either 1 L or 2 L jars for making stock solutions."]
["2003-03-18","LDD added enhancements to the velocity gradient worksheets (provided by J. Schulze)."]
["2003-03-18","LDD added calibration data worksheet (provided by J. Roney)."]
["2003-03-18","LDD revised stock solution help screen to include additional information and consolidate calculations; "]
[null,"modifications also made to input screen."]
["2003-04-01","LDD added head loss calculations to HydraulicMixHELP worksheet (provided by J. Williams)."]
["2004-08-26","LDD added flexibilty to stock solution table."]
["2005-05-09","LDD corrected error in V^2/2g formula (in HydraulicMixHELP).  Added two rapid mix segments."]
["2008-04-11","LDD added updated calibration data worksheet and modified flow and volume inputs to be consistent."]
[null,"Renamed file to JARTEST32."]
["2008-07-10","LDD fixed hidden row in the HydraulicMix worksheet and corrected spelling errors in worksheets."]
[null,"Added pictures and mixer clarification.  Changed name to JARTEST33."]
["2009-08-03","LDD added additional tables for hydraulic, turbine, and paddle mixing calculations.  Modified calibratation"]
[null,"data collection forms.  Changed name to JARTEST34."]
["2009-08-03","LDD added NozzleMix worksheet for pump injection rapid mix applications.  Enhancements made to"]
[null,"additional hydaulic input tables.  Changed name to JARTEST35."]
["2010-02-18","LDD corrected temperature cell reference error in 2nd and 3rd flocculation mix tables."]
[null,"Added 3rd segment for rapid mix.  Change to JARTEST36."]
["2010-06-30","LDD added notes on plate settler concepts and corrected formula to determine settling distance in plates"]
[null,"or tubes (minor change)."]
["2010-09-30","LDD change name to JARTEST37.  No changes other than those noted for 6/30/09."]
["2017-10-12","LDD added flexibility to use either 1 or 2 L square jars for the testing. File name updated to JARTEST38."]
[null,"Added section to determine equivalent G x T for rapid mix."]
[null,"Added open channel flow friction losses calculations in hydraulic mix worksheet."]
["2018-12-06","LDD corrected formula errors in Hydraulic Mix worksheet related to open channel head loss."]
[null,"Modified G x T input section in Jar Setting Help worksheet. File name updated to JarTest39."]
[]
["Model by: Process Applications, Inc. Fort Collins, CO 970-223-5787"]

{"sheet":"Lookup","index":1,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"\"Jar Test Summary for \"&B4&\" WTP\"","v":{"$error":"#N/A"}}]
[null,"Step 1 - Enter plant background data.  Enter data in cells with white background only."]
[null,"Plant/Train Name","Date","Test No.","Test Time, hr:min",null,"Test Date",null,"Warning:  Do not enter data"]
[null,{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!C5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!B5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!E5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!F5)","v":{"$error":"#N/A"}},null,"Test No.",null,"  in this screen.  It is used to"]
[null,"Water Source","Flow Rate (MGD)","Raw Turbidity","Water Temp (C)","Raw pH","Raw Alk. (mg/L)","Raw TOC (mg/L)","  retrieve data from the database."]
[null,{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!D5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!I5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!G5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!H5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!J5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!L5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!K5)","v":{"$error":"#N/A"}}]
[null,"Chemical","Coagulant","Other Chemical 1","Other Chemical 2","Settled Turbidity","IFE Turbidity","Treated TOC (mg/L)"]
[null,"Name",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!M5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!O5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!Q5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!S5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!T5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!U5)","v":{"$error":"#N/A"}}]
[null,"Current Dose",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$N$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$P$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$R$5)","v":{"$error":"#N/A"}}]
[]
[null,"Step 2 - Enter jar test settings.  Click Jar Settings HELP Button for guidance on setting parameters."]
[null,null,"Rapid Mix #1","Rapid Mix #2","Floc, Stage 1","Floc, Stage 2","Floc, Stage 3","Settle Time (min)"]
[null,"Speed (RPM)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$V$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$X$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$Z$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AB$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AD$5)","v":{"$error":"#N/A"}}]
[null,"Time (sec, min)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$W$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$Y$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AA$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AC$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AE$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AF$5)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Step 3 - Enter desired dose to determine volume of stock solution for each jar."]
[null,"Click on Stock Solution HELP Button for guidance on preparing stock solutions."]
[]
[null,"Desired Stock","Coagulant","Other Chemical 1","Other Chemical 2","Raw Water Added to Jars (mL)"]
[null,"Solution Concentration (%)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AG$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AH$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AI$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AJ$5)","v":{"$error":"#N/A"}}]
[null,"Coagulant Jar #","1","2","3","4","5","6"]
[null,"Coagulant Dose (mg/L)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AK$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AU$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BE$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BO$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BY$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CI$5)","v":{"$error":"#N/A"}}]
[null,"Stock Solution (mL)",{"$f":"IF(C23=0,\"\",StockSolutionsHELP!$E$11*C23/(StockSolutionsHELP!$D$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(D23=0,\"\",StockSolutionsHELP!$E$11*D23/(StockSolutionsHELP!$D$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(E23=0,\"\",StockSolutionsHELP!$E$11*E23/(StockSolutionsHELP!$D$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(F23=0,\"\",StockSolutionsHELP!$E$11*F23/(StockSolutionsHELP!$D$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(G23=0,\"\",StockSolutionsHELP!$E$11*G23/(StockSolutionsHELP!$D$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(H23=0,\"\",StockSolutionsHELP!$E$11*H23/(StockSolutionsHELP!$D$48*10000))","v":{"$error":"#N/A"}}]
[]
[null,"Other Chem. 1 Dose (mg/L)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AL$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AV$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BF$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BP$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BZ$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CJ$5)","v":{"$error":"#N/A"}}]
[null,"Stock Solution (mL)",{"$f":"IF(C26=0,\"\",StockSolutionsHELP!$E$11*C26/(StockSolutionsHELP!$E$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(D26=0,\"\",StockSolutionsHELP!$E$11*D26/(StockSolutionsHELP!$E$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(E26=0,\"\",StockSolutionsHELP!$E$11*E26/(StockSolutionsHELP!$E$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(F26=0,\"\",StockSolutionsHELP!$E$11*F26/(StockSolutionsHELP!$E$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(G26=0,\"\",StockSolutionsHELP!$E$11*G26/(StockSolutionsHELP!$E$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(H26=0,\"\",StockSolutionsHELP!$E$11*H26/(StockSolutionsHELP!$E$48*10000))","v":{"$error":"#N/A"}}]
[]
[null,"Other Chem. 2 Dose (mg/L)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AM$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AW$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BG$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BQ$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CA$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CK$5)","v":{"$error":"#N/A"}}]
[null,"Stock Solution (mL)",{"$f":"IF(C29=0,\"\",StockSolutionsHELP!$E$11*C29/(StockSolutionsHELP!$F$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(D29=0,\"\",StockSolutionsHELP!$E$11*D29/(StockSolutionsHELP!$F$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(E29=0,\"\",StockSolutionsHELP!$E$11*E29/(StockSolutionsHELP!$F$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(F29=0,\"\",StockSolutionsHELP!$E$11*F29/(StockSolutionsHELP!$F$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(G29=0,\"\",StockSolutionsHELP!$E$11*G29/(StockSolutionsHELP!$F$48*10000))","v":{"$error":"#N/A"}},{"$f":"IF(H29=0,\"\",StockSolutionsHELP!$E$11*H29/(StockSolutionsHELP!$F$48*10000))","v":{"$error":"#N/A"}}]
[]
[null,"Step 4 - Conduct jar test and enter results below. "]
[null,"Jar Number","1","2","3","4","5","6"]
[null,"Coagulant Dose (mg/L)",{"$f":"IF(DataEntry!C23=0,0,DataEntry!C23)","v":0},{"$f":"IF(DataEntry!D23=0,0,DataEntry!D23)","v":0},{"$f":"IF(DataEntry!E23=0,0,DataEntry!E23)","v":0},{"$f":"IF(DataEntry!F23=0,0,DataEntry!F23)","v":0},{"$f":"IF(DataEntry!G23=0,0,DataEntry!G23)","v":0},{"$f":"IF(DataEntry!H23=0,0,DataEntry!H23)","v":0}]
[null,"Other Chemical 1 (mg/L)",{"$f":"IF(DataEntry!C26=0,0,DataEntry!C26)","v":0},{"$f":"IF(DataEntry!D26=0,0,DataEntry!D26)","v":0},{"$f":"IF(DataEntry!E26=0,0,DataEntry!E26)","v":0},{"$f":"IF(DataEntry!F26=0,0,DataEntry!F26)","v":0},{"$f":"IF(DataEntry!G26=0,0,DataEntry!G26)","v":0},{"$f":"IF(DataEntry!H26=0,0,DataEntry!H26)","v":0}]
[null,"Other Chemical 2 (mg/L)",{"$f":"IF(DataEntry!C29=0,0,DataEntry!C29)","v":0},{"$f":"IF(DataEntry!D29=0,0,DataEntry!D29)","v":0},{"$f":"IF(DataEntry!E29=0,0,DataEntry!E29)","v":0},{"$f":"IF(DataEntry!F29=0,0,DataEntry!F29)","v":0},{"$f":"IF(DataEntry!G29=0,0,DataEntry!G29)","v":0},{"$f":"IF(DataEntry!H29=0,0,DataEntry!H29)","v":0}]
[null,"Time to floc formation (min)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AN$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AX$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BH$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BR$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CB$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CL$5)","v":{"$error":"#N/A"}}]
[null,"Size of floc at mix end (mm)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AO$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AY$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BI$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BS$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CC$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CM$5)","v":{"$error":"#N/A"}}]
[null,"Settled Turbidity (NTU)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AP$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AZ$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BJ$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BT$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CD$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CN$5)","v":{"$error":"#N/A"}}]
[null,"Settled pH",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AQ$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BA$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BK$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BU$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CE$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CO$5)","v":{"$error":"#N/A"}}]
[null,"Filtered Turbidity (NTU)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AR$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BB$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BL$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BV$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CF$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CP$5)","v":{"$error":"#N/A"}}]
[null,"Settled TOC (mg/L)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AS$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BC$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BM$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BW$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CG$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CQ$5)","v":{"$error":"#N/A"}}]
[null,"Filtered UV Absorb. (cm-1)",{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$AT$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BD$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BN$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$BX$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CH$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$D$49,DatabaseJar,Database!$CR$5)","v":{"$error":"#N/A"}}]
[null,"TOC Removal, %",{"$f":"IF($G$6=0,,1-C42/$H$6)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"TOC Removal, %"]
[]
[]
[null,null,null,null,null,{"$f":"VLOOKUP(Lookup!$G$49,DatabaseJar,Database!$B$5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Lookup!$G$49,DatabaseJar,Database!$E$5)","v":{"$error":"#N/A"}}]
[null,null,"retrievedatesample",{"$f":"ROUND(DataEntry!$H$3,0)+ROUND(DataEntry!$H$4/100,2)","v":0},null,"Inputdatetest",{"$f":"ROUND(DataEntry!$C$4,0)+ROUND(DataEntry!$D$4/100,2)","v":0}]
[]
[null,null,"lookupdatesample",{"$f":"ROUND($C$4,0)+ROUND($D$4/100,2)","v":{"$error":"#N/A"}},null,"lookupdatesample",{"$f":"ROUND(F48,0)+ROUND(G48/100,2)","v":{"$error":"#N/A"}}]
[]
[null,null,"CheckRetrieveDate",{"$f":"IF(D51=D49,1,2)","v":{"$error":"#N/A"}},null,"CheckDatabase",{"$f":"IF(G51=G49,1,2)","v":{"$error":"#N/A"}}]

{"sheet":"DataEntry","index":2,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Jar Test Summary for \"&B4&\" WTP\"","v":"Jar Test Summary for  WTP"}]
[null,"Step 1 - Enter plant background data.  Enter data in cells with white background only"]
[null,"Plant/Train Name","Date","Test No.","Test Time, hr:min",null,"Test Date"]
[null,null,null,null,null,null,"Test No."]
[null,"Water Source","Flow Rate (MGD)","Raw Turbidity","Water Temp (C)","Raw pH","Raw Alk. (mg/L)","Raw TOC (mg/L)"]
[]
[null,"Chemical","Coagulant","Other Chemical 1","Other Chemical 2","Settled Turbidity","IFE Turbidity","Treated TOC (mg/L)"]
[null,"Name"]
[null,"Current Dose"]
[]
[null,"Step 2 - Enter jar test settings.  Click Jar Settings HELP Button for guidance on setting parameters."]
[null,null,"Rapid Mix #1","Rapid Mix #2","Floc, Stage 1","Floc, Stage 2","Floc, Stage 3","Settle Time (min)"]
[null,"Speed (RPM)"]
[null,"Time (min)"]
[]
[]
[null,"Step 3 - Enter desired dose to determine volume of stock solution for each jar."]
[null,"Click on Stock Solution HELP Button for guidance on preparing stock solutions."]
[]
[null,"Desired Stock","Coagulant","Other Chemical 1","Other Chemical 2","Raw Water Added to Jars (mL)"]
[null,"Solution Concentration (%)"]
[null,"Jar #","1","2","3","4","5","6"]
[null,"Coagulant Dose (mg/L)"]
[null,"Stock Solution (mL)",{"$f":"IF(C23=0,\"\",$F$21*C23/($C$21*10000))","v":""},"","","","",""]
[]
[null,"Other Chem. 1 Dose (mg/L)"]
[null,"Stock Solution (mL)",{"$f":"IF(C26=0,\"\",$F$21*C26/($D$21*10000))","v":""},"","","","",""]
[]
[null,"Neat Chem.  Dose (mg/L)"]
[null,"Stock Solution (mL)",{"$f":"'Neat chemical help'!C12","v":30.907407407407405},{"$f":"'Neat chemical help'!D12","v":18.544444444444444},{"$f":"'Neat chemical help'!E12","v":92.722222222222229},{"$f":"'Neat chemical help'!F12","v":24.725925925925925},{"$f":"'Neat chemical help'!G12","v":27.816666666666666},{"$f":"'Neat chemical help'!H12","v":40.17962962962963},null,"Note:  If adding chemical Neat (No stock solution) click here for neat chemical help:"]
[]
[null,"Step 4 - Conduct jar test and enter results below. "]
[null,"Jar Number","1","2","3","4","5","6"]
[null,"Coagulant Dose (mg/L)",{"$f":"IF(DataEntry!C23=0,0,DataEntry!C23)","v":0},{"$f":"IF(DataEntry!D23=0,0,DataEntry!D23)","v":0},{"$f":"IF(DataEntry!E23=0,0,DataEntry!E23)","v":0},{"$f":"IF(DataEntry!F23=0,0,DataEntry!F23)","v":0},{"$f":"IF(DataEntry!G23=0,0,DataEntry!G23)","v":0},{"$f":"IF(DataEntry!H23=0,0,DataEntry!H23)","v":0}]
[null,"Other Chemical 1 (mg/L)",{"$f":"IF(DataEntry!C26=0,0,DataEntry!C26)","v":0},{"$f":"IF(DataEntry!D26=0,0,DataEntry!D26)","v":0},{"$f":"IF(DataEntry!E26=0,0,DataEntry!E26)","v":0},{"$f":"IF(DataEntry!F26=0,0,DataEntry!F26)","v":0},{"$f":"IF(DataEntry!G26=0,0,DataEntry!G26)","v":0},{"$f":"IF(DataEntry!H26=0,0,DataEntry!H26)","v":0}]
[null,"Other Chemical 2 (mg/L)",{"$f":"IF(DataEntry!C29=0,0,DataEntry!C29)","v":0},{"$f":"IF(DataEntry!D29=0,0,DataEntry!D29)","v":0},{"$f":"IF(DataEntry!E29=0,0,DataEntry!E29)","v":0},{"$f":"IF(DataEntry!F29=0,0,DataEntry!F29)","v":0},{"$f":"IF(DataEntry!G29=0,0,DataEntry!G29)","v":0},{"$f":"IF(DataEntry!H29=0,0,DataEntry!H29)","v":0}]
[null,"Time to floc formation (min)"]
[null,"Size of floc at mix end (mm)"]
[null,"Settled Turbidity (NTU)"]
[null,"Settled pH"]
[null,"Filtered Turbidity (NTU)"]
[null,"Settled TOC (mg/L)"]
[null,"Filtered UV Absorb. (cm-1)"]
[null,"TOC Removal, %",{"$f":"IF($H$6=0,,1-C42/$H$6)","v":0},0,0,0,0,0]

{"sheet":"StockSolutionsHELP","index":3,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,1,1,7],[58,5,58,6],[51,5,51,6],[52,5,52,6],[47,5,47,6],[46,5,46,6],[40,5,40,6],[41,5,41,6],[37,2,37,6],[38,5,38,6],[59,5,59,6],[60,5,60,6],[12,4,12,5],[54,5,54,6],[57,5,57,6],[39,5,39,6],[53,5,53,6]]}
[]
[null,"Stock Solution HELP Screen"]
[null,"The goal of this guideline is to help you \"Prepare a Stock Solution\""]
[null,"Table 1:  Determining the concentration of the stock solutions"]
[null,null,"To use Table 1, FIRST determine how much raw water you will be adding to each jar.  For example, if you are using 2,000 mL jars and conducting a"]
[null,null,"conventional jar test, you will typically be adding 2,000 mL to each jar.  SECOND, consider the chemical dosages that are to be added to each jar."]
[null,null,"For example, you may want the alum dosage to increase by 10 mg/L in each jar.  THIRD, identify the stock solution concentration (%) that you need"]
[null,null,"to prepare and transfer this information to Table 3 below."]
[]
[null,null,"Table 1"]
[null,null,"How much raw water are you going to put in each jar?",null,2000,"mL"]
[null,null,"How much do you want the dosage (mg/L)",null,"Concentration of the stock"]
[null,null,"to change for each milliliter (mL) of stock solution",null,"solution that you need to prepare"]
[null,null,"that you add to a jar?",null,"(%)","(Mg/L)"]
[null,null,{"$f":"F15/($E$11)","v":0.05},null,0.01,{"$f":"E15*10000","v":100}]
[null,null,0.25,null,0.05,{"$f":"E16*10000","v":500}]
[null,null,0.5,null,0.1,1000]
[null,null,1,null,0.2,2000]
[null,null,2.5,null,0.5,5000]
[null,null,5,null,1,10000]
[null,null,10,null,2,{"$f":"E21*10000","v":20000}]
[null,null,15,null,3,{"$f":"E22*10000","v":30000}]
[null,null,20,null,4,40000]
[]
[null,null,5,null,{"$f":"C25*E11/10000","v":1},{"$f":"E25*10000","v":10000}]
[]
[null,null,"The following equation is used to calculate the Stock Solution Concentration in Table 1:"]
[null,null,"Stock Solution Concentration (%) = "]
[null,null,null,"Desired Dosage (mg/L) x Volume of Raw Water (mL)"]
[null,null,null,"Amount of Stock Solution added to each jar (1 mL) x 10,000 (mg/L to % conversion factor)"]
[null,"Table 2: Determining the product strength of liquid chemicals"]
[null,null,"To determine how much liquid chemical you must use to prepare the stock solution, you must first determine the product strength.  Product strength"]
[null,null,"is the actual (reactive) chemical that is contained in each gallon of liquid.  To determine the product strength, you must know the product specific "]
[null,null,"gravity and percent concentration.  For example, liquid alum has a product specific gravity of 1.35 and a percent concentration of about 48 %."]
[null,null,"Product specific gravity and percent concentration can be determined from the product supplier and product information sources such as MSDS."]
[null,null,"Once the product specific gravity and percent concentration are known, Table 2 can be used to determine the product strength."]
[]
[null,null,"Table 2"]
[null,null,null,"Coagulant","Other Chemical 1","Other Chemical 2"]
[null,null,"Product Strength (%)",0.48499999999999999,1]
[null,null,"Specific Gravity",1.335,1.2]
[null,null,"Product Strength (lb/gal)",{"$f":"IF(D40=\"\",\"\",D40*D41*8.34)","v":5.3999414999999988},{"$f":"IF(E40=\"\",\"\",E40*E41*8.34)","v":10.007999999999999},{"$f":"IF(F40=\"\",\"\",F40*F41*8.34)","v":""}]
[]
[null,"Table 3: Making the stock solution"]
[null,null,"Table 3"]
[null,null,"Step 1 - Select desired stock solution concentration from Table 1 above"]
[null,null,"Desired Stock","Coagulant","Other Chemical 1","Other Chemical 2"]
[null,null,"Solution Concentration (%)",20,0.2]
[]
[null,null,"Step 2 - Determine amount of product to add to flask of indicated size"]
[null,null,"If product is a DRY"]
[null,null,"Parameter","Coagulant","Other Chemical 1","Other Chemical 2"]
[null,null,"Flask size (mL)"]
[null,null,"Product Purity, %"]
[null,null,"Weight to add to flask, gm",{"$f":"IF(D54=0,,D48*10000*D53/1000000/(D54/100))","v":0},{"$f":"IF(E54=0,,E48*10000*E53/1000000/(E54/100))","v":0},{"$f":"IF(F54=0,,F48*10000*F53/1000000/(F54/100))","v":0},{"$f":"IF(G54=0,,G48*10000*G53/1000000/(G54/100))","v":0}]
[]
[null,null,"If product is LIQUID"]
[null,null,"Parameter","Coagulant","Other Chemical 1","Other Chemical 2"]
[null,null,"Flask size (mL)",1000,1000]
[null,null,"Product Strength, lb/gal",5.4,10.01]
[null,null,"Volume to add to flask, mL",{"$f":"IF(D60=0,0,$D$48*1000*8.34/100/D60*D59/1000)","v":308.88888888888886},{"$f":"IF(E60=0,0,$E$48*1000*8.34/100/E60*E59/1000)","v":1.6663336663336663},{"$f":"IF(F60=0,0,F48*1000*8.34/100/F60*F59/1000)","v":0},{"$f":"IF(G60=0,0,$E$48*1000*8.34/100/G60*G59/1000)","v":0}]
[null,null,"The following equation is used to determine the product volume:"]
[null,null,"Product volume (mL) = ","(% solution) x (flask volume, mL) x (8.34 lb/gal)"]
[null,null,null,"              100  x (product strength, lb/gal)"]

{"sheet":"Calculate","index":4,"n_rows":6,"n_cols":97,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current","Other","Current Dose","Other","Current Dose",null,null,null,"Rapid Mix","Rapid Mix","Rapid Mix","Rapid Mix","Floc","Floc","Floc","Floc","Floc","Floc",null,"Stock Solution Concentration",null,null,"Raw Water","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6"]
["Date &",null,"Plant/Train","Water","Test","Test","Raw","Water","Water","Raw","Raw","Raw","Coagulant","Dose","Chemical 1","Other","Chemical 2","Other","Settled","IFE","Finished","Speed","Speed","Speed","Speed","Stage 1","Stage 1","Stage 2","Stage 2","Stage 3","Stage 3","Settle","Coagulant","Other","Other","Added to","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to","Floc","Settled","Settled","Filtered","Settled","Settled","Last"]
["Sample No.","Date","Name","Source","No.","Time","Turbidity","Temperature","Flow","pH","TOC","Alkalinity","Name","Coagulant","Name","Chemical 1","Name","Chemical 2","Turbidity","Turbidity","TOC","#1","#1","#2","#2","Speed","Time","Speed","Time","Speed","Time","Time",null,"Chemical 1","Chemical 2","Jars","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Floc","Size","Turb","pH","Turb","TOC","UV absorb","Column"]
["#","m/d/y",null,null,"#","hr:min","NTU","C","MGD","units","mg/L","mg/L",null,null,null,null,null,null,null,null,null,"RPM","min","RPM","min","RPM","min","RPM","min","RPM","min","min","%","%","%","mL","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97]
[{"$f":"ROUND(B6+E6/100,2)","v":0},{"$f":"DataEntry!C4","v":"00:00:00"},{"$f":"DataEntry!B4","v":0},{"$f":"DataEntry!B6","v":0},{"$f":"DataEntry!$D$4","v":0},{"$f":"DataEntry!E4","v":"00:00:00"},{"$f":"DataEntry!D6","v":0},{"$f":"DataEntry!E6","v":0},{"$f":"DataEntry!C6","v":0},{"$f":"DataEntry!F6","v":0},{"$f":"DataEntry!H6","v":0},{"$f":"DataEntry!G6","v":0},{"$f":"DataEntry!C8","v":0},{"$f":"DataEntry!C9","v":0},{"$f":"DataEntry!D8","v":0},{"$f":"DataEntry!D9","v":0},{"$f":"DataEntry!E8","v":0},{"$f":"DataEntry!E9","v":0},{"$f":"DataEntry!F8","v":0},{"$f":"DataEntry!G8","v":0},{"$f":"DataEntry!H8","v":0},{"$f":"DataEntry!C13","v":0},{"$f":"DataEntry!C14","v":0},{"$f":"DataEntry!D13","v":0},{"$f":"DataEntry!D14","v":0},{"$f":"DataEntry!E13","v":0},{"$f":"DataEntry!E14","v":0},{"$f":"DataEntry!F13","v":0},{"$f":"DataEntry!F14","v":0},{"$f":"DataEntry!G13","v":0},{"$f":"DataEntry!G14","v":0},{"$f":"DataEntry!H14","v":0},{"$f":"DataEntry!C21","v":0},{"$f":"DataEntry!D21","v":0},{"$f":"DataEntry!E21","v":0},{"$f":"DataEntry!F21","v":0},{"$f":"DataEntry!C23","v":0},{"$f":"DataEntry!C26","v":0},{"$f":"DataEntry!C29","v":0},{"$f":"DataEntry!C37","v":0},{"$f":"DataEntry!C38","v":0},{"$f":"DataEntry!C39","v":0},{"$f":"DataEntry!C40","v":0},{"$f":"DataEntry!C41","v":0},{"$f":"DataEntry!C42","v":0},{"$f":"DataEntry!C43","v":0},{"$f":"DataEntry!D23","v":0},{"$f":"DataEntry!D26","v":0},{"$f":"DataEntry!D29","v":0},{"$f":"DataEntry!D37","v":0},{"$f":"DataEntry!D38","v":0},{"$f":"DataEntry!D39","v":0},{"$f":"DataEntry!D40","v":0},{"$f":"DataEntry!D41","v":0},{"$f":"DataEntry!D42","v":0},{"$f":"DataEntry!D43","v":0},{"$f":"DataEntry!E23","v":0},{"$f":"DataEntry!E26","v":0},{"$f":"DataEntry!D29","v":0},{"$f":"DataEntry!E37","v":0},{"$f":"DataEntry!E38","v":0},{"$f":"DataEntry!E39","v":0},{"$f":"DataEntry!E40","v":0},{"$f":"DataEntry!E41","v":0},{"$f":"DataEntry!E42","v":0},{"$f":"DataEntry!E43","v":0},{"$f":"DataEntry!F23","v":0},{"$f":"DataEntry!F26","v":0},{"$f":"DataEntry!F29","v":0},{"$f":"DataEntry!F37","v":0},{"$f":"DataEntry!F38","v":0},{"$f":"DataEntry!F39","v":0},{"$f":"DataEntry!F40","v":0},{"$f":"DataEntry!F41","v":0},{"$f":"DataEntry!F42","v":0},{"$f":"DataEntry!F43","v":0},{"$f":"DataEntry!G23","v":0},{"$f":"DataEntry!G26","v":0},{"$f":"DataEntry!G29","v":0},{"$f":"DataEntry!G37","v":0},{"$f":"DataEntry!G38","v":0},{"$f":"DataEntry!G39","v":0},{"$f":"DataEntry!G40","v":0},{"$f":"DataEntry!G41","v":0},{"$f":"DataEntry!G42","v":0},{"$f":"DataEntry!G43","v":0},{"$f":"DataEntry!H23","v":0},{"$f":"DataEntry!H26","v":0},{"$f":"DataEntry!H29","v":0},{"$f":"DataEntry!H37","v":0},{"$f":"DataEntry!H38","v":0},{"$f":"DataEntry!H39","v":0},{"$f":"DataEntry!H40","v":0},{"$f":"DataEntry!H41","v":0},{"$f":"DataEntry!H42","v":0},{"$f":"DataEntry!H43","v":0}]

{"sheet":"JarG","index":5,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":true,"merged":[[16,2,16,8],[16,12,16,18]]}
[]
[null,"G calculations for jar testing"]
[null,null,null,"Impller: 1 inch x 3 inch (25.4 mm x 76 mm)",null,null,null,{"$f":"25.4*76","v":1930.3999999999999},null,null,null,null,null,null,"Impeller: 40 mm x 60 mm",null,null,{"$f":"40*60","v":2400}]
[null,"Input 2 liter jar:",null,null,null,null,null,null,null,null,null,null,"Input 1 liter jar based on EC Engineering design and mixing curve."]
["Diameter","D",{"$f":"7.5/2.54/12","v":0.24606299212598426},"ft",null,null,null,null,null,null,null,"Diameter","D",{"$f":"7.7/2.54/12","v":0.25262467191601051},"ft","7.7 cm versus 6 cm to match vendor curve"]
[null,"Np",3,"FBT","Adjusted from recommended value of 3.6 for flat blade turbine to fit original curve",null,null,null,null,null,null,null,"Np",3,"FBT"]
["Specific gravity","S",1,null,null,null,null,null,null,null,null,"Specific gravity","S",1]
["Volume","V",{"$f":"2/3.785/7.48","v":7.0641923155715977E-2},"ft3",null,null,null,null,null,null,null,"Volume","V",{"$f":"1/3.785/7.48","v":3.5320961577857989E-2},"ft3"]
["Viscosity","u",3.7459999999999997E-5,"lb-sec/ft2 @ 0C",null,null,null,null,null,null,null,null,"u",3.7459999999999997E-5,"lb-sec/ft2 @ 0C"]
[null,"u",{"$f":"0.00003229","v":3.2289999999999997E-5},"lb-sec/ft2 @ 4C",null,null,null,null,null,null,null,null,"u",{"$f":"0.00003229","v":3.2289999999999997E-5},"lb-sec/ft2 @ 4C"]
[null,"u",2.7350000000000001E-5,"lb-sec/ft2 @ 10C",null,null,null,null,null,null,null,null,"u",2.7350000000000001E-5,"lb-sec/ft2 @ 10C"]
[null,"u",2.3589999999999999E-5,"lb-sec/ft2 @ 16C",null,null,null,null,null,null,null,null,"u",2.3589999999999999E-5,"lb-sec/ft2 @ 16C"]
[null,"u",2.05E-5,"lb-sec/ft2 @ 21C",null,null,null,null,null,null,null,null,"u",2.05E-5,"lb-sec/ft2 @ 21C"]
[null,"u",{"$f":"0.00001799","v":1.7989999999999999E-5},"lb-sec/ft2 @ 27C",null,null,null,null,null,null,null,null,"u",{"$f":"0.00001799","v":1.7989999999999999E-5},"lb-sec/ft2 @ 27C"]
[null,"u",1.5950000000000001E-5,"lb-sec/ft2 @ 32C",null,null,null,null,null,null,null,null,"u",1.5950000000000001E-5,"lb-sec/ft2 @ 32C"]
[]
[null,null,"Temperature C",null,null,null,null,null,null,null,null,null,"Temperature C"]
[null,"RPM",0,4,10,16,21,27,32,null,null,"RPM",0,4,10,16,20,27,32]
[null,10,{"$f":"((550*$C$6*$C$5^5*B19^3*$C$7/(6.12*10^7))/($C$9*$C$8))^0.5","v":3.0315648948300629},{"$f":"((550*$C$6*$C$5^5*B19^3*$C$7/(6.12*10^7))/($C$10*$C$8))^0.5","v":3.2652522196724179},{"$f":"((550*$C$6*$C$5^5*B19^3*$C$7/(6.12*10^7))/($C$11*$C$8))^0.5","v":3.547905882619939},{"$f":"((550*$C$6*$C$5^5*B19^3*$C$7/(6.12*10^7))/($C$12*$C$8))^0.5","v":3.8202060270121501},{"$f":"((550*$C$6*$C$5^5*B19^3*$C$7/(6.12*10^7))/($C$13*$C$8))^0.5","v":4.098017657327615},{"$f":"((550*$C$6*$C$5^5*B19^3*$C$7/(6.12*10^7))/($C$14*$C$8))^0.5","v":4.374568024447087},{"$f":"((550*$C$6*$C$5^5*B19^3*$C$7/(6.12*10^7))/($C$15*$C$8))^0.5","v":4.645905931917869},null,null,10,{"$f":"((550*$N$6*$N$5^5*L19^3*$N$7/(6.12*10^7))/($N$9*$N$8))^0.5","v":4.5788405644555512},{"$f":"((550*$N$6*$N$5^5*L19^3*$N$7/(6.12*10^7))/($N$10*$N$8))^0.5","v":4.9317991978702764},{"$f":"((550*$N$6*$N$5^5*L19^3*$N$7/(6.12*10^7))/($N$11*$N$8))^0.5","v":5.3587160221821},{"$f":"((550*$N$6*$N$5^5*L19^3*$N$7/(6.12*10^7))/($N$12*$N$8))^0.5","v":5.7699950117813152},{"$f":"((550*$N$6*$N$5^5*L19^3*$N$7/(6.12*10^7))/($N$13*$N$8))^0.5","v":6.1895984859920459},{"$f":"((550*$N$6*$N$5^5*L19^3*$N$7/(6.12*10^7))/($N$14*$N$8))^0.5","v":6.6072969628549973},{"$f":"((550*$N$6*$N$5^5*L19^3*$N$7/(6.12*10^7))/($N$15*$N$8))^0.5","v":7.0171226009340222}]
[null,30,{"$f":"((550*$C$6*$C$5^5*B20^3*$C$7/(6.12*10^7))/($C$9*$C$8))^0.5","v":15.752473272863607},{"$f":"((550*$C$6*$C$5^5*B20^3*$C$7/(6.12*10^7))/($C$10*$C$8))^0.5","v":16.966748231999041},{"$f":"((550*$C$6*$C$5^5*B20^3*$C$7/(6.12*10^7))/($C$11*$C$8))^0.5","v":18.435459747510706},{"$f":"((550*$C$6*$C$5^5*B20^3*$C$7/(6.12*10^7))/($C$12*$C$8))^0.5","v":19.85037280249766},{"$f":"((550*$C$6*$C$5^5*B20^3*$C$7/(6.12*10^7))/($C$13*$C$8))^0.5","v":21.293924378417444},{"$f":"((550*$C$6*$C$5^5*B20^3*$C$7/(6.12*10^7))/($C$14*$C$8))^0.5","v":22.730922238525693},{"$f":"((550*$C$6*$C$5^5*B20^3*$C$7/(6.12*10^7))/($C$15*$C$8))^0.5","v":24.140835363802147},null,null,30,{"$f":"((550*$N$6*$N$5^5*L20^3*$N$7/(6.12*10^7))/($N$9*$N$8))^0.5","v":23.792353492183114},{"$f":"((550*$N$6*$N$5^5*L20^3*$N$7/(6.12*10^7))/($N$10*$N$8))^0.5","v":25.626380350316261},{"$f":"((550*$N$6*$N$5^5*L20^3*$N$7/(6.12*10^7))/($N$11*$N$8))^0.5","v":27.844705241258364},{"$f":"((550*$N$6*$N$5^5*L20^3*$N$7/(6.12*10^7))/($N$12*$N$8))^0.5","v":29.981773559472664},{"$f":"((550*$N$6*$N$5^5*L20^3*$N$7/(6.12*10^7))/($N$13*$N$8))^0.5","v":32.16209716856887},{"$f":"((550*$N$6*$N$5^5*L20^3*$N$7/(6.12*10^7))/($N$14*$N$8))^0.5","v":34.332522121081162},{"$f":"((550*$N$6*$N$5^5*L20^3*$N$7/(6.12*10^7))/($N$15*$N$8))^0.5","v":36.462038603272781}]
[null,50,{"$f":"((550*$C$6*$C$5^5*B21^3*$C$7/(6.12*10^7))/($C$9*$C$8))^0.5","v":33.893925915210104},{"$f":"((550*$C$6*$C$5^5*B21^3*$C$7/(6.12*10^7))/($C$10*$C$8))^0.5","v":36.506629634348009},{"$f":"((550*$C$6*$C$5^5*B21^3*$C$7/(6.12*10^7))/($C$11*$C$8))^0.5","v":39.66679365654786},{"$f":"((550*$C$6*$C$5^5*B21^3*$C$7/(6.12*10^7))/($C$12*$C$8))^0.5","v":42.711201822267824},{"$f":"((550*$C$6*$C$5^5*B21^3*$C$7/(6.12*10^7))/($C$13*$C$8))^0.5","v":45.817230273894928},{"$f":"((550*$C$6*$C$5^5*B21^3*$C$7/(6.12*10^7))/($C$14*$C$8))^0.5","v":48.909157374303234},{"$f":"((550*$C$6*$C$5^5*B21^3*$C$7/(6.12*10^7))/($C$15*$C$8))^0.5","v":51.942807404189317},null,null,50,51.192993801280601,55.13919128908438,59.912266488582233,64.510505380888603,69.201814840539967,73.871825782358371,78.453815710693021]
[null,100,{"$f":"((550*$C$6*$C$5^5*B22^3*$C$7/(6.12*10^7))/($C$9*$C$8))^0.5","v":95.866499422718107},{"$f":"((550*$C$6*$C$5^5*B22^3*$C$7/(6.12*10^7))/($C$10*$C$8))^0.5","v":103.25634149085299},{"$f":"((550*$C$6*$C$5^5*B22^3*$C$7/(6.12*10^7))/($C$11*$C$8))^0.5","v":112.19463512989009},{"$f":"((550*$C$6*$C$5^5*B22^3*$C$7/(6.12*10^7))/($C$12*$C$8))^0.5","v":120.80552176461121},{"$f":"((550*$C$6*$C$5^5*B22^3*$C$7/(6.12*10^7))/($C$13*$C$8))^0.5","v":129.59069688742673},{"$f":"((550*$C$6*$C$5^5*B22^3*$C$7/(6.12*10^7))/($C$14*$C$8))^0.5","v":138.3359873659594},{"$f":"((550*$C$6*$C$5^5*B22^3*$C$7/(6.12*10^7))/($C$15*$C$8))^0.5","v":146.91644539747631},null,null,100,144.79565226450563,155.9571842786151,169.45747964132818,182.46326325039038,195.7322901766467,208.94107579734737,221.90090039596294]
[null,300,{"$f":"((550*$C$6*$C$5^5*B23^3*$C$7/(6.12*10^7))/($C$9*$C$8))^0.5","v":498.13694323176065},{"$f":"((550*$C$6*$C$5^5*B23^3*$C$7/(6.12*10^7))/($C$10*$C$8))^0.5","v":536.53568899751917},{"$f":"((550*$C$6*$C$5^5*B23^3*$C$7/(6.12*10^7))/($C$11*$C$8))^0.5","v":582.98042514486497},{"$f":"((550*$C$6*$C$5^5*B23^3*$C$7/(6.12*10^7))/($C$12*$C$8))^0.5","v":627.72390459352334},{"$f":"((550*$C$6*$C$5^5*B23^3*$C$7/(6.12*10^7))/($C$13*$C$8))^0.5","v":673.37301359184323},{"$f":"((550*$C$6*$C$5^5*B23^3*$C$7/(6.12*10^7))/($C$14*$C$8))^0.5","v":718.81487589914411},{"$f":"((550*$C$6*$C$5^5*B23^3*$C$7/(6.12*10^7))/($C$15*$C$8))^0.5","v":763.40024368754314},null,null,300,752.38027931159786,810.37730092783045,880.52689338404718,948.10692739347394,1017.0548138033002,1085.6896772073167,1153.0309011932657]
[]
[]
[]
[null,null,null,null,null,null,"Water Viscosity Table"]
[null,null,null,null,null,null,0,3.7459999999999997E-5]
[null,null,null,null,null,null,4.4000000000000004,{"$f":"0.00003229","v":3.2289999999999997E-5}]
[null,null,null,null,null,null,10,2.7350000000000001E-5]
[null,"Temperature","Trend Visc.",null,null,null,15.6,2.3589999999999999E-5]
[null,{"$f":"DataEntry!E6","v":0},{"$f":"1.3391*10^-8*B32^2-1.0818*10^-6*B32+3.7125*10^-5","v":3.7125000000000001E-5},null,null,null,21.1,2.05E-5]
[null,null,null,null,null,null,26.7,{"$f":"0.00001799","v":1.7989999999999999E-5}]
[null,null,null,null,null,null,32.200000000000003,1.5950000000000001E-5]

{"sheet":"Neat chemical help","index":6,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,2,5,3],[6,2,6,3]]}
[null,"Help Page for Determining How many uLs of neat chemical to add to jars"]
[]
[null,"Note:  all cells are protected except the yellow cells for data entry."]
[]
[]
[null,"Product Strengh (lb/gal)",5.4]
[null,"Volume of Jar (L)",2]
[]
[]
[null,null,"Desired dosage (mg/L) Jar 1","Desired dosage (mg/L) Jar 2","Desired dosage (mg/L) Jar 3","Desired dosage (mg/L) Jar 4","Desired dosage (mg/L) Jar 5","Desired dosage (mg/L) Jar 6"]
[null,null,10,6,30,8,9,13]
[null,"uLs of chemical to add directly to jar",{"$f":"C11*8.345*$C$7/$C$6","v":30.907407407407405},{"$f":"D11*8.345*$C$7/$C$6","v":18.544444444444444},92.722222222222229,24.725925925925925,27.816666666666666,40.17962962962963]
[]
[]
[null,"uLs of chemical to add directly to jar is calculated by the equation:  ",null,null,null,"uLs=","Desired Dosage (mg/L) x 8.34 (lb/gal) x jar volume (L)"]
[null,null,null,null,null,null,"Product strengh (lb/gal) x weight of water (1 mg/uL)"]

{"sheet":"Calibrate Data","index":7,"n_rows":63,"n_cols":6,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[null,"Jar Test Calibration Parameters"]
[null,"Chemicals added at Rapid Mix"]
[null,"Parameter","Chemical 1","Chemical 2","Chemical 3","Chemical 4"]
[null,"Liquid (description)","Aqua Hawk 457 (Hawkins product)"]
[null,"  Specific gravity","1.15 - 1.28"]
[null,"  Product strength, %",100]
[null,"  Product strength, lb/gal"]
[null,"Dry (description)"]
[null,"  Product purity, %"]
[null,"Comments/Notes:"]
[]
[]
[]
[]
[null,"Rapid Mix (collect data for appropriate configuration)"]
[null,"Hydraulic Mixing Stage","Segment 1 with channel","Segment 2 with turbine mixer","Segment 3 with pipes"]
[null,"  Basin or pipe dimensions","28 ft x 3.1 ft x 1.2 ft deep","18 ft x 7 ft x 5.6 ft deep","24 in dia x 130 ft"]
[null,"  Basin or pipe volume, ft3",{"$f":"28*3.1*1.2","v":104.16},{"$f":"(18-6.5)*7*5.6","v":450.79999999999995},{"$f":"PI()*1^2*130","v":408.40704496667308}]
[null,"  Head loss across basin/pipe, ft"]
[null,"Turbine Mixing Stage"]
[null,"  Blade diameter (tip to tip), ft",null,"3.1 ft dia"]
[null,"  Description of blade1",null,"4 blade with 45 deg pitch"]
[null,"  Basin volume, ft3",null,{"$f":"18*7*5.6","v":705.59999999999991}]
[null,"  Turbine speed (actual and max), rpm",null,"operating @ 48 hz (60 max); 84 max rpm output; est operating at 67 rpm"]
[null,"Comments/Notes (include length and diameter of pipe, # bends if used as rapid mix): Nozzle  mixing system"]
[]
[]
[]
[]
[null,"Jar Test Calibration Parameters (Page 2)"]
[null,"Flocculator (collect data for appropriate configuration)"]
[null,"  Note:  If using multiple stage flocculation, determine information for each stage."]
[null,"Turbine Mixing Stage","1st","2nd","3rd","4th"]
[null,"  Basin dimensions","20.6 ft x 20 ft x 12.5 ft deep"]
[null,"  Description of blade1","4 blade with 45 deg pitch"]
[null,"  Blade diameter (tip to tip), ft","3 ft"]
[null,"  Basin volume, ft3",{"$f":"20.6*20*12.5","v":5150}]
[null,"  Turbine speed (actual and max), rpm","20 rpm actual"]
[null,"Paddle Mixing Stage"]
[null,"  Area of paddles (L x W x No. paddles), ft2"]
[null,"  Diameter of paddles (tip to tip), ft"]
[null,"  Basin volume, ft3"]
[null,"  Paddle speed (actual and max), rpm"]
[null,"Walking Beam Stage"]
[null,"  Area of paddles (L x W x No. paddles), ft2"]
[null,"  Paddle stroke length, ft"]
[null,"  Basin volume, ft3"]
[null,"  Paddle speed (actual and max), rpm"]
[null,"Comments/Notes:"]
[]
[]
[null,"Sedimentation (collect data for appropriate configuration)"]
[null,"Without Tubes","118.16 ft X 41.33 ft x 12.25 ft deep per basin (2 basins)"]
[null,"  Surface area, ft2",{"$f":"118.16*41.33*2","v":9767.105599999999}]
[null,"With Tubes"]
[null,"  Tube opening, inches"]
[null,"  Tube angle, degrees"]
[null,"  Tube depth, inches"]
[null,"  Area covered by tubes, ft2"]
[null,"Comments/Notes:"]
[]
[]
[null,"  1 See Turbine Mix Help worksheet"]

{"sheet":"JarSettingsHELP","index":8,"n_rows":92,"n_cols":19,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Jar Settings HELP Screen"]
[null,null,"Step 1 - Determine rapid mix time based on available rapid mix volume and flow rate through rapid mix.  To determine the mixing"]
[null,null,"energy (G value), use plant design info or refer to HELP buttons for type of mixing."]
[null,null,null,"Enter square jar volume (1 or 2)",2,"Liters"]
[null,null,null,"1 or 2 Liter"]
[null,null,"Stage","1st","2nd","3rd",null,null,null,null,null,"When G value exceeds G achievable by jar @ 300 rpm, equivalent G x t can be used to add mixing time."]
[null,null,"Rapid Mix Volume (ft3)",104,451,204]
[null,null,"Rapid Mix Flow Rate (MGD)",3.74,3.74,{"$f":"3.74/2","v":1.87},null,null,null,null,null,null,"Full Scale","Jar @ 300 rpm"]
[null,null,"Mix Time (sec)",{"$f":"IF(D9=\"\",\"CALCULATION\",D8*7.48*1440*60/D9/1000000)","v":17.9712},{"$f":"IF(E9=\"\",\"CALCULATION\",E8*7.48*1440*60/E9/1000000)","v":77.9328},{"$f":"IF(F9=\"\",\"CALCULATION\",F8*7.48*1440*60/F9/1000000)","v":70.502399999999994},null,null,null,null,null,"Time, sec",null,{"$f":"IF(N11=\"\",\"CALC\",M12/N11)","v":"CALC"}]
[null,null,"G Value (sec-1)",28.8,392,25.3,null,null,null,null,null,"G, sec-1"]
[null,null,"Jar RPM",{"$f":"IF(D11=0,\"CALCULATION\",IF($E$5=2,((D11^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((D11^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":44.721528862137454},{"$f":"IF(E11=0,\"CALCULATION\",IF($E$5=2,((E11^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((E11^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":254.94452797245759},{"$f":"IF(F11=0,\"CALCULATION\",IF($E$5=2,((F11^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((F11^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":41.020598983141632},null,null,null,null,null,"G x t",{"$f":"IF(M10=\"calculation\",\"CALC\",M10*M11)","v":0}]
[]
[null,null,"Step 2 - Determine flocculation time per stage based on available flocculation volume and flow rate through the flocculation stage."]
[null,null,"To determine mixing energy (G value) for each stage, use plant design info or refer to HELP buttons for type of mixing."]
[]
[null,null,"Table 3",null,null,null,null,null,null,null,null,"Additional transition segments"]
[null,null,"STAGE","1st","2nd","3rd","4th","     Hydraulic & Turbine Mix buttons"]
[null,null,"Volume (ft3)",{"$f":"5150*4","v":20600},null,null,null,"     may also apply to flocculation"]
[null,null,"Flow Rate (MGD)",3.74]
[null,null,"Floc Time (min)",{"$f":"IF(D20=\"\",\"CALCULATION\",JarSettingsHELP!D19*7.48*1440/D20/1000000)","v":59.328000000000003},{"$f":"IF(E20=\"\",\"CALCULATION\",JarSettingsHELP!E19*7.48*1440/E20/1000000)","v":"CALCULATION"},{"$f":"IF(F20=\"\",\"CALCULATION\",JarSettingsHELP!F19*7.48*1440/F20/1000000)","v":"CALCULATION"},{"$f":"IF(G20=\"\",\"CALCULATION\",JarSettingsHELP!G19*7.48*1440/G20/1000000)","v":"CALCULATION"},null,null,null,null,{"$f":"IF(L20=\"\",\"CALCULATION\",JarSettingsHELP!L19*7.48*1440/L20/1000000)","v":"CALCULATION"},{"$f":"IF(M20=\"\",\"CALCULATION\",JarSettingsHELP!M19*7.48*1440/M20/1000000)","v":"CALCULATION"}]
[null,null,"G Value (sec-1)",18]
[null,null,"Jar RPM",{"$f":"IF(D22=0,\"CALCULATION\",IF($E$5=2,((D22^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((D22^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":32.691635918222147},{"$f":"IF(E22=0,\"CALCULATION\",IF($E$5=2,((E22^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((E22^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":"CALCULATION"},{"$f":"IF(F22=0,\"CALCULATION\",IF($E$5=2,((F22^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((F22^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":"CALCULATION"},{"$f":"IF(G22=0,\"CALCULATION\",IF($E$5=2,((G22^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((G22^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":"CALCULATION"},null,null,null,null,{"$f":"IF(L22=0,\"CALCULATION\",IF($E$5=2,((L22^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((L22^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":"CALCULATION"},{"$f":"IF(M22=0,\"CALCULATION\",IF($E$5=2,((M22^2*JarG!$C$32*JarG!$C$8*6.12*10^7)/(550*JarG!$C$6*diameter^5*JarG!$C$7))^(1/3),((M22^2*JarG!$C$32*JarG!$N$8*6.12*10^7)/(550*JarG!$C$6*diameter1^5*JarG!$C$7))^(1/3)))","v":"CALCULATION"}]
[]
[null,null,"Step 3 - Determine the jar settling time based on the sed basin surface overflow rate (rise rate) and corresponding particle settling"]
[null,null,"velocity.  If the sed basins have tube settlers installed, use input box on the right."]
[]
[null,null,null,null,null,null,"Conventional Basin with Tube or Plate Settlers",null,null,null,null,null,null,null,null,null,null,null,"Plate opening (typ. 5 cm)"]
[null,null,"Conventional Basin",null,null,null,"Tube or Plate Opening (inch)"]
[null,null,"Flow Rate (MGD)",null,3.74,null,"Tube or Plate Angle (degrees)",null,null,null,null,{"$f":"IF(I33=0,,I32*1000000/1440/7.48/I33)","v":0},"rise rate (ft/min)"]
[null,null,"Surface Area (ft2)",null,9767,null,"Tube or Plate Depth (inch)",null,null,null,null,{"$f":"IF(I30=0,,L30/SIN((I30*PI()/180)))","v":0},"tube velocity (ft/min)"]
[null,null,"Settling velocity (cm/min)",null,{"$f":"IF(E31=0,\"CALCULATION\",(IF(E30=\"\",,E30*1000000/1440/7.48/E31*12*2.54)))","v":1.0835807651615983},null,"Flow Rate (MGD)",null,null,null,null,{"$f":"IF(I30=0,,I31/SIN((I30*PI()/180))/12)","v":0},"tube path length (ft)",null,null,null,null,null,"Plate angle (typ. 60 degrees)"]
[null,null,"Floc to Sed Transition Time - (min)",null,0.5,null,"Surface Area (ft2)",null,null,null,null,{"$f":"IF(L30=0,,L32/L31)","v":0},"tube dt (min)"]
[null,null,"Jar Settling Time * (min)",null,{"$f":"IF(E32=\"CALCULATION\",\"CALCULATION\",10/E32+E33)","v":9.7286614173228365},null,"Settling Velocity (cm/min)",null,{"$f":"IF(L33=0,\"CALCULATION\",L34/L33)","v":"CALCULATION"},null,null,{"$f":"I29*2.54/COS(I30*PI()/180)","v":0},"tube settling distance (cm)",null,null,null,"plate settling distance = plate opening / cos plate angle"]
[null,null,"* Based on 10 cm sample depth in jar",null,null,null,"Floc to Sed Transition Time - (min)"]
[null,null,null,null,null,null,"Sample Time (min)",null,{"$f":"IF(I34=\"CALCULATION\",\"CALCULATION\",10/I34+I35)","v":"CALCULATION"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"* Estimated based on data provided by MCR jar design (formerly EC Engineering)"]
[null,null,null,"   http://www.mcrpt.com"]

{"sheet":"HydraulicMixHELP","index":9,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[null,"Calculation of Velocity Gradient (G) for Hydraulic Mixing"]
[]
[null,"Parameters","Input","Input","Input","Units"]
[null,"Description","Channel RM","Pipe RM"]
[null,"Basin/Pipe Volume",104,204,null,"ft3"]
[null,"Flow Rate",2.2999999999999998,{"$f":"2.3/2","v":1.1499999999999999},null,"MGD"]
[null,"Head loss (hL)",7.0000000000000001E-3,2.12E-2,null,"ft",null,"  Note: Headloss through piping segments can be estimated"]
[null,"Weight of Fluid (w)",62.4,62.4,62.4,"lb/ft3"]
[null,"Water Temperature",{"$f":"DataEntry!E6","v":0},{"$f":"C9","v":0},{"$f":"C9","v":0},"C"]
[null,"Dynamic viscosity (u)",{"$f":"1.3391*10^-8*C9^2-1.0818*10^-6*C9+3.7125*10^-5","v":3.7125000000000001E-5},{"$f":"C10","v":3.7125000000000001E-5},{"$f":"C10","v":3.7125000000000001E-5},"lb-sec/ft2"]
[null,"Velocity Gradient (G)",{"$f":"IF(C6=\"\",,((C8*C7)/(C10*(C5*7.48/(C6*10^6)*1440*60)))^0.5)","v":20.06539261400745},{"$f":"IF(D6=\"\",,((D8*D7)/(D10*(D5*7.48/(D6*10^6)*1440*60)))^0.5)","v":17.630034429746548},{"$f":"IF(E6=\"\",,((E8*E7)/(E10*(E5*7.48/(E6*10^6)*1440*60)))^0.5)","v":0},"sec-1",null,"  by paging down and using the Hazen-Williams input box."]
[]
[null,"Note:  Input current water temperature in the DataEntry Screen."]
[null,"The velocity gradient calculation requires a current value to be accurate."]
[null,"Transfer the velocity gradient value to the JarSettingsHELP worksheet."]
[]
[null,"The Hazen-Williams equation for determination of head loss in pressure pipe (should be used only for turbulent flow)."]
[]
[null,"Input"]
[null,"Flow (MGD) = ",{"$f":"3.74/2","v":1.87}]
[null,"Pipe Diameter (inches) = ",24]
[null,"Length (feet) = ",130]
[null,"C = ",120]
[null,"Calculations"]
[null,"Q (gpm) = ",{"$f":"C20*10^6/1440","v":1298.6111111111111}]
[null,null,{"$f":"C25*0.002228","v":2.8933055555555556},null,null,null,null,null,"Velocity Head","ft",6.1144289543386106E-3]
[null,"A (sf) = ",{"$f":"3.14*(C21/12/2)^2","v":3.14}]
[null,"V (fps) = ",{"$f":"(C26)/C27","v":0.92143489030431702}]
[null,"S = ",{"$f":"(C28/(1.318*C23*(C21/12/2/2)^0.63))^1.852","v":1.6318915264966393E-4}]
[null,"Head loss - friction (ft) = ",{"$f":"C29*C22","v":2.1214589844456309E-2}]
[null,"Pressure head (psi) = ",{"$f":"C30*0.4335","v":9.1965246975718104E-3}]
[null,"Should minor losses be considered?",{"$f":"IF((C21/12)*500>C22,\"YES\",\"NO\")","v":"YES"}]
[]
[null,"V^2/2g =",{"$f":"(C28^2)/(32.2*2)","v":1.3183885979349823E-2}]
[null,"K factors for minor losses",null,"HL (ft)"]
[null,"90o bend",0.3,{"$f":"C36*C34","v":3.9551657938049463E-3}]
[null,"Squared edged inlet",0.5,{"$f":"C37*C34","v":6.5919429896749114E-3}]
[null,"Inward projecting pipe",1,{"$f":"C38*C34","v":1.3183885979349823E-2}]
[]
[null,"Hazen-Williams Coefficient"]
[null,"Water Supply and Pollution Control, 4th ed., Viessman and Hammer, 1985"]
[null,"Pipe Material","C"]
[null,"New cast iron",130]
[null,"5-yr-old iron",120]
[null,"20-yr-old cast iron",100]
[null,"Average concrete",130]
[null,"New welded steel",120]
[null,"Asbestos cement",140]
[null,"Plastic",150]
[]
[null,"The Manning equation for determination of head loss in open channel flow (should be used only for turbulent flow)."]
[null,"ISCO Open Channel Flow Measurement Handbook p. 67"]
[null,"Parameters","Input","Input","Input"]
[null,"Description","Infuent Channel"]
[null,"Width, ft",3.1]
[null,"Height, ft",1.2]
[null,"Length, ft",28]
[null,"Channel area, ft^2",{"$f":"C55*C56","v":3.7199999999999998},{"$f":"D55*D56","v":0},{"$f":"E55*E56","v":0}]
[null,"Channel wettted perimeter (3 sides)",{"$f":"2*C56+C55","v":5.5},{"$f":"2*D56+D55","v":0},{"$f":"2*E56+E55","v":0}]
[null,"Channel hydraulic diameter, ft",{"$f":"C58/C59","v":0.67636363636363628},{"$f":"D58/D59","v":{"$error":"#DIV/0!"}},{"$f":"E58/E59","v":{"$error":"#DIV/0!"}}]
[null,"Flow rate, MGD",{"$f":"2600*1440/10^6","v":3.7440000000000002}]
[null,"Flow rate, ft^3/sec",{"$f":"C61*10^6/7.48/1440/60","v":5.7932263814616753},{"$f":"D61*10^6/7.48/1440/60","v":0},{"$f":"E61*10^6/7.48/1440/60","v":0}]
[null,"Viscosity of water - µ, lb-sec/ft^2",{"$f":"C10","v":3.7125000000000001E-5},{"$f":"D10","v":3.7125000000000001E-5},{"$f":"E10","v":3.7125000000000001E-5}]
[null,"N factor",1.2E-2]
[null,"Channel hydraulic slope",{"$f":"((C62*C64)/(1.49*C58*C60^(2/3)))^2","v":2.6495456575286982E-4},{"$f":"((D62*D64)/(1.49*D58*D60^(2/3)))^2","v":{"$error":"#DIV/0!"}},{"$f":"((E62*E64)/(1.49*E58*E60^(2/3)))^2","v":{"$error":"#DIV/0!"}}]
[null,"Channel friction loss due to flow, ft",{"$f":"IF(C57=\"\",\"CALCULATION\",C65*C57)","v":7.4187278410803546E-3},{"$f":"IF(D57=\"\",\"CALCULATION\",D65*D57)","v":"CALCULATION"},{"$f":"IF(E57=\"\",\"CALCULATION\",E65*E57)","v":"CALCULATION"}]
[null,"Minor loss"]
[null,"Opening Height, ft"]
[null,"Opening Width, ft"]
[null,"Flow rate thru opening, MGD"]
[null,"Flow rate thru opening, ft^3/sec",{"$f":"C70*10^6/7.48/1440/60","v":0},{"$f":"D70*10^6/7.48/1440/60","v":0},{"$f":"E70*10^6/7.48/1440/60","v":0}]
[null,"Velocity, ft/sec",{"$f":"C71/(C68*C69)","v":{"$error":"#DIV/0!"}},{"$f":"D71/(D68*D69)","v":{"$error":"#DIV/0!"}},{"$f":"E71/(E68*E69)","v":{"$error":"#DIV/0!"}}]
[null,"Minor loss due to opening, ft",{"$f":"IF(C68=\"\",\"CALCULATION\",(C71/(0.61*C68*C69))^2/64.4)","v":"CALCULATION"},{"$f":"IF(D68=\"\",\"CALCULATION\",(D71/(0.61*D68*D69))^2/64.4)","v":"CALCULATION"},{"$f":"IF(E68=\"\",\"CALCULATION\",(E71/(0.61*E68*E69))^2/64.4)","v":"CALCULATION"}]
[null,"Minor loss"]
[null,"Opening Height, ft"]
[null,"Opening Width, ft"]
[null,"Flow rate thru opening, MGD"]
[null,"Flow rate thru opening, ft^3/sec",{"$f":"C77*10^6/7.48/1440/60","v":0},{"$f":"D77*10^6/7.48/1440/60","v":0},{"$f":"E77*10^6/7.48/1440/60","v":0}]
[null,"Velocity, ft/sec",{"$f":"C78/(C75*C76)","v":{"$error":"#DIV/0!"}},{"$f":"D78/(D75*D76)","v":{"$error":"#DIV/0!"}},{"$f":"E78/(E75*E76)","v":{"$error":"#DIV/0!"}}]
[null,"Minor loss due to opening, ft",{"$f":"IF(C75=\"\",\"CALCULATION\",(C78/(0.61*C75*C76))^2/64.4)","v":"CALCULATION"},{"$f":"IF(D75=\"\",\"CALCULATION\",(D78/(0.61*D75*D76))^2/64.4)","v":"CALCULATION"},{"$f":"IF(E75=\"\",\"CALCULATION\",(E78/(0.61*E75*E76))^2/64.4)","v":"CALCULATION"}]
[null,"Total losses",{"$f":"C66+C73+C80","v":{"$error":"#VALUE!"}},{"$f":"D66+D73+D80","v":{"$error":"#VALUE!"}},{"$f":"E66+E73+E80","v":{"$error":"#VALUE!"}}]

{"sheet":"NozzleMixHELP","index":10,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[20,4,20,14],[21,4,35,9]]}
[null,"Calculation of Velocity Gradient (G) for Pump Injection thru Nozzle"]
[]
[null,"Parameters","Input",null,"Units"]
[null,"Description"]
[null,"Coefficient of discharge",null,null,null,0.85,"Obtained from Tacoma jar test speadsheet"]
[null,"Area of nozzle(s)",null,null,"ft2"]
[null,"Flow rate through nozzle(s)",null,null,"gpm"]
[null,"Diameter of pipeline or area of flow",null,null,"ft2"]
[null,"Jet velocity",null,null,"ft/sec",{"$f":"F8*72","v":0},"ft^2 area for 72 nozzles"]
[null,"Water horsepower",null,null,"Hp"]
[null,"Mixing zone length",null,null,"ft","See site specific calculation below"]
[null,"Mixing volume",{"$f":"C8*C11","v":0},{"$f":"D8*D11","v":0},"ft3"]
[null,"Weight of Fluid (w)",62.4,62.4,"lb/ft3"]
[null,"Water temperature",{"$f":"DataEntry!E6","v":0},{"$f":"DataEntry!E6","v":0},"C"]
[null,"Dynamic viscosity (u)",{"$f":"1.3391*10^-8*C14^2-1.0818*10^-6*C14+3.7125*10^-5","v":3.7125000000000001E-5},{"$f":"1.3391*10^-8*D14^2-1.0818*10^-6*D14+3.7125*10^-5","v":3.7125000000000001E-5},"lb-sec/ft2"]
[null,"Velocity gradient (G)",{"$f":"IF(C6=\"\",,(C10*550/C15/C12)^0.5)","v":0},{"$f":"IF(D6=\"\",,(D10*550/D15/D12)^0.5)","v":0},"sec-1"]
[]
[null,"Note:  Input current water temperature in the DataEntry Screen."]
[null,"The velocity gradient calculation requires a current value to be accurate."]
[null,"Transfer the velocity gradient value to the JarSettingsHELP worksheet.",null,null,"Source: Tacoma WTP Jar Testing Spreadsheet (open channel nozzle array example)"]
[null,null,null,null,"Time for Flash Mixing"]
[null,null,null,null,"The time for flash mixing is calculated based on the area in which mixing occurs.\n\nMixing occurs across the channel for the length x, which can be found by:\n\n\nTime to Flash mix is found by:\n\n\n\nWhere v = velocity of flow in channel\n\nFlash mix dimensions can be found on drawing 5M-7"]
[]
[null,null,null,null,null,null,null,null,null,null,"Plan View"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Mixing zone x = ",null,2.3090000000000002,"feet"]

{"sheet":"TurbineMixHELP","index":11,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[9,1,9,2],[12,1,12,2],[2,1,2,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[3,1,3,2],[63,1,63,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[70,1,70,2],[73,1,73,2],[64,1,64,2],[98,1,98,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[91,1,91,2],[92,1,92,2],[95,1,95,2]]}
[null,"Calculation of Velocity Gradient (G) for Vertical Turbine Mixers"]
[]
[null,"Parameters",null,"Input","Units","Note:"]
[null,"Description",null,"Rapid Mix Basin",null,"Input current water temperature in the DataEntry screen - the"]
[null,"Blade Diameter (D)",null,3.1,"ft","velocity gradient calculation requires a current value to be accurate."]
[null,"Impeller Number (Np)",null,1.6,"See Below"]
[null,"Volume (V)",null,451,"ft3"]
[null,"Weight of Fluid (w)",null,62.4,"lb/ft3"]
[null,"Acceleration of Gravity",null,32.200000000000003,"ft/sec2"]
[null,"Water Temperature",null,{"$f":"DataEntry!E6","v":0},"C"]
[null,"Dynamic viscosity (u)",null,{"$f":"1.3391*10^-8*D10^2-1.0818*10^-6*D10+3.7125*10^-5","v":3.7125000000000001E-5},"lb-sec/ft2"]
[]
[null,"Controller Setting (%)",null,"RPM (R)",{"$f":"\"G @ \"&D10&\" C\"","v":"G @ 0 C"}]
[null,"Min",0,0,{"$f":"IF($D$7=\"\",\"\",(($D$6*($D$8/$D$9)*$D$5^5*(D14/60)^3)/($D$11*$D$7))^0.5)","v":0}]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C14))","v":0.1},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D14))","v":8.4},{"$f":"IF($D$7=\"\",\"\",(($D$6*($D$8/$D$9)*$D$5^5*(D15/60)^3)/($D$11*$D$7))^0.5)","v":12.06143932114721}]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C15))","v":0.2},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D15))","v":16.8},34.11490213941304]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C16))","v":0.30000000000000004},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D16))","v":25.200000000000003},62.673077149908103]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C17))","v":0.4},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D17))","v":33.6},96.491514569177681]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C18))","v":0.5},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D18))","v":42},134.85099114287036]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C19))","v":0.6},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D19))","v":50.4},177.26623140211069]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C20))","v":0.7},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D20))","v":58.8},223.38098228075862]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C21))","v":0.79999999999999993},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D21))","v":67.2},272.91921711530432]
[null,null,{"$f":"IF($C24=0,\"\",(($C$24-$C$14)/10+C22))","v":0.89999999999999991},{"$f":"IF($D24=0,\"\",(($D$24-$D$14)/10+D22))","v":75.600000000000009},325.65886167097472]
[null,"Max",1,84,381.41620114740272]
[null,"Actual",0.8,{"$f":"IF(OR(C25=\"\",D24=\"\"),\"\",IF(C25=C14,D14,(D24-D14)/((C24-C14)/(C25-C14))+D14))","v":67.2},272.91921711530432]
[]
[null,null,null,null,null,null,"NOTE:"]
[null,"Source of information, equations, and images:  Mixing in Coagulation and Flocculation, AWWARF 1991 &",null,null,null,null,"You will need to enter the data for each vertical turbine mixer"]
[null,"Water Works Engineering, Qasim & Zhu, Prentice Hall PTR  2000",null,null,null,null,"and then transfer the resulting G value to the appropriate box"]
[null,null,null,null,null,null,"in the JarSettingsHELP screen. For example, if the plant has a"]
[null,"Impeller Power Number (Np)",null,null,null,null,"two-stage mixer, the table will need to be filled out for each stage."]
[null,"Propeller Type",null,null,"Np",null,"Page down for additional turbine mixer data entry tables."]
[null,"Flat Blade Turbine (radial flow)",null,null,"2.6 - 3.6"]
[null,"Disk Turbine (radial flow)",null,null,"5.1 - 6.2"]
[null,"Curved Blade Turbine (radial flow)",null,null,2.5]
[null,"45o Pitched Blade Turbine (axial flow)",null,null,"1.36 - 1.94"]
[null,"4-Blade Hydrofoil",null,null,0.4]
[null,"3-Blade Hydrofoil",null,null,0.3]
[null,"Propeller (axial flow)",null,null,"0.3 - 0.7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Flat blade turbine"]
[]
[]
[]
[]
[null,"Parameters",null,"Input","Units"]
[null,"Description",null,"Flocculation"]
[null,"Blade Diameter (D)",null,3,"ft"]
[null,"Impeller Number (Np)",null,1.6,"See Below"]
[null,"Volume (V)",null,5150,"ft3"]
[null,"Weight of Fluid (w)",null,62.4,"lb/ft3"]
[null,"Acceleration of Gravity",null,32.200000000000003,"ft/sec2"]
[null,"Water Temperature",null,{"$f":"DataEntry!E6","v":0},"C"]
[null,"Dynamic viscosity (u)",null,{"$f":"1.3391*10^-8*D71^2-1.0818*10^-6*D71+3.7125*10^-5","v":3.7125000000000001E-5},"lb-sec/ft2"]
[]
[null,"Controller Setting (%)",null,"RPM (R)",{"$f":"\"G @ \"&D71&\" C\"","v":"G @ 0 C"}]
[null,"Min",0,0,{"$f":"IF($D$68=\"\",\"\",(($D$67*($D$69/$D$70)*$D$66^5*(D75/60)^3)/($D$72*$D$68))^0.5)","v":0}]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C75))","v":0.1},{"$f":"IF($D$85=0,\"\",(($D$85-$D$75)/10+D75))","v":5.6},{"$f":"IF($D$68=\"\",\"\",(($D$67*($D$69/$D$70)*$D$66^5*(D76/60)^3)/($D$72*$D$68))^0.5)","v":1.7899702231023928}]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C76))","v":0.2},{"$f":"IF($D$85=0,\"\",(($D$85-$D$75)/10+D76))","v":11.2},5.0628003315107968]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C77))","v":0.30000000000000004},16.799999999999997,9.3009581113462279]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C78))","v":0.4},22.4,14.319761784819143]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C79))","v":0.5},28,20.012475482787078]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C80))","v":0.6},33.6,26.307082208259775]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C81))","v":0.7},39.200000000000003,33.150712451778148]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C82))","v":0.79999999999999993},44.800000000000004,40.502402652086388]
[null,null,{"$f":"IF($C85=0,\"\",(($C$24-$C$14)/10+C83))","v":0.89999999999999991},50.400000000000006,48.329196023764617]
[null,"Max",1,56,56.603828488833074]
[null,"Actual",0.36,{"$f":"IF(OR(C86=\"\",D85=\"\"),\"\",IF(C86=C75,D75,(D85-D75)/((C85-C75)/(C86-C75))+D75))","v":20.16},12.226426953587945]
[]
[]
[null,"Parameters",null,"Input","Units"]
[null,"Description"]
[null,"Blade Diameter (D)",null,null,"ft"]
[null,"Impeller Number (Np)",null,null,"See Below"]
[null,"Volume (V)",null,null,"ft3"]
[null,"Weight of Fluid (w)",null,62.4,"lb/ft3"]
[null,"Acceleration of Gravity",null,32.200000000000003,"ft/sec2"]
[null,"Water Temperature",null,{"$f":"DataEntry!E6","v":0},"C"]
[null,"Dynamic viscosity (u)",null,{"$f":"1.3391*10^-8*D96^2-1.0818*10^-6*D96+3.7125*10^-5","v":3.7125000000000001E-5},"lb-sec/ft2"]
[]
[null,"Controller Setting (%)",null,"RPM (R)",{"$f":"\"G @ \"&D96&\" C\"","v":"G @ 0 C"}]
[null,"Min",0,0,{"$f":"IF($D$93=\"\",\"\",(($D$92*($D$94/$D$95)*$D$91^5*(D100/60)^3)/($D$97*$D$93))^0.5)","v":""}]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C100))","v":0.1},{"$f":"IF($D$110=0,\"\",(($D$110-$D$100)/10+D100))","v":""},{"$f":"IF($D$93=\"\",\"\",(($D$92*($D$94/$D$95)*$D$91^5*(D101/60)^3)/($D$97*$D$93))^0.5)","v":""}]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C101))","v":0.2},{"$f":"IF($D$110=0,\"\",(($D$110-$D$100)/10+D101))","v":""},""]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C102))","v":0.30000000000000004},"",""]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C103))","v":0.4},"",""]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C104))","v":0.5},"",""]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C105))","v":0.6},"",""]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C106))","v":0.7},"",""]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C107))","v":0.79999999999999993},"",""]
[null,null,{"$f":"IF($C110=0,\"\",(($C$24-$C$14)/10+C108))","v":0.89999999999999991},"",""]
[null,"Max",1,null,""]
[null,"Actual",null,{"$f":"IF(OR(C111=\"\",D110=\"\"),\"\",IF(C111=C100,D100,(D110-D100)/((C110-C100)/(C111-C100))+D100))","v":""},""]

{"sheet":"PaddleMixHELP","index":12,"n_rows":97,"n_cols":7,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[null,"Calculation of Velocity Gradient (G) for Paddle-Type Mixers"]
[]
[null,null,"Parameters","Input","Units","NOTE:"]
[null,null,"Description","1st stage flocculation",null,"Input current water temperature in the DataEntry Screen - the"]
[null,null,"Coefficient of Drag (Cd)",1.8,null,"velocity gradient calculation requires a current value to be accurate."]
[null,null,"Area of Paddles (A)",null,"ft2"]
[null,null,"Diameter of Flocculator (d)",null,"ft"]
[null,null,"Volume of basin (V)",null,"ft3"]
[null,null,"Water Temperature",{"$f":"DataEntry!E6","v":0},"C"]
[null,null,"u",{"$f":"1.3391*10^-8*D9^2-1.0818*10^-6*D9+3.7125*10^-5","v":3.7125000000000001E-5},"lb-sec/ft2 @ 40F"]
[]
[null,"Controller Setting (%)",null,"RPM (R) ",{"$f":"\"G @ \"&D9&\" C\"","v":"G @ 0 C"}]
[null,"Min",0,0,{"$f":"IF($D8=\"\",\"\",(($D5*$D6*(0.75*PI()*$D7*D13/60)^3)/($D10*$D8))^0.5)","v":""}]
[null,null,{"$f":"IF($C$23=\"\",\"\",(($C$23-$C$13)/10+C13))","v":0.1},{"$f":"IF($D$23=\"\",\"\",(($D$23-$D$13)/10+D13))","v":""},{"$f":"IF($D$8=\"\",\"\",(($D$5*$D$6*(0.75*PI()*$D$7*D14/60)^3)/($D$10*$D$8))^0.5)","v":""}]
[null,null,0.2,"",""]
[null,null,0.30000000000000004,"",""]
[null,null,0.4,"",""]
[null,null,0.5,"",""]
[null,null,0.6,"",""]
[null,null,0.7,"",""]
[null,null,0.79999999999999993,"",""]
[null,null,0.89999999999999991,"",""]
[null,"Max",1,null,""]
[null,"Actual",null,{"$f":"IF(OR(C24=\"\",D23=\"\"),\"\",IF(C24=C13,D13,(D23-D13)/((C23-C13)/(C24-C13))+D13))","v":""},""]
[]
[null,null,null,null,"Source:  Mixing in Coagulation and Flocculation, AWWARF 1991"]
[]
[null,"NOTE:"]
[null,"You will need to enter the data for each paddle-type mixer"]
[null,"and then tranfer the resulting G value to the appropriate"]
[null,"box on the JarSettingsHELP screen. For example, "]
[null,"if the plant has three-stage mixer, the table will"]
[null,"need to be filled out once for each stage."]
[null,"Page down for additional paddle-type mixer data entry tables."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Typical horizontal paddle-type flocculator"]
[]
[]
[null,null,"Parameters","Input","Units"]
[null,null,"Description","2nd stage flocculation"]
[null,null,"Coefficient of Drag (Cd)",1.8]
[null,null,"Area of Paddles (A)",null,"ft2"]
[null,null,"Diameter of Flocculator (d)",null,"ft"]
[null,null,"Volume of basin (V)",null,"ft3"]
[null,null,"Water Temperature",{"$f":"DataEntry!E55","v":0},"C"]
[null,null,"u",{"$f":"1.3391*10^-8*D58^2-1.0818*10^-6*D58+3.7125*10^-5","v":3.7125000000000001E-5},"lb-sec/ft2 @ 40F"]
[]
[null,"Controller Setting (%)",null,"RPM (R) ",{"$f":"\"G @ \"&D58&\" C\"","v":"G @ 0 C"}]
[null,"Min",0,0,{"$f":"IF($D57=\"\",\"\",(($D54*$D55*(0.75*PI()*$D56*D62/60)^3)/($D59*$D57))^0.5)","v":""}]
[null,null,{"$f":"IF($C$23=\"\",\"\",(($C$23-$C$13)/10+C62))","v":0.1},{"$f":"IF($D$72=\"\",\"\",(($D$72-$D$62)/10+D62))","v":""},{"$f":"IF($D$57=\"\",\"\",(($D$54*$D$55*(0.75*PI()*$D$56*D63/60)^3)/($D$59*$D$57))^0.5)","v":""}]
[null,null,0.2,{"$f":"IF($D$72=\"\",\"\",(($D$72-$D$62)/10+D63))","v":""},""]
[null,null,0.30000000000000004,"",""]
[null,null,0.4,"",""]
[null,null,0.5,"",""]
[null,null,0.6,"",""]
[null,null,0.7,"",""]
[null,null,0.79999999999999993,"",""]
[null,null,0.89999999999999991,"",""]
[null,"Max",1,null,""]
[null,"Actual",null,{"$f":"IF(OR(C73=\"\",D72=\"\"),\"\",IF(C73=C62,D62,(D72-D62)/((C72-C62)/(C73-C62))+D62))","v":""},""]
[]
[]
[null,null,"Parameters","Input","Units"]
[null,null,"Description","3rd stage flocculation"]
[null,null,"Coefficient of Drag (Cd)",1.8]
[null,null,"Area of Paddles (A)",null,"ft2"]
[null,null,"Diameter of Flocculator (d)",null,"ft"]
[null,null,"Volume of basin (V)",null,"ft3"]
[null,null,"Water Temperature",{"$f":"DataEntry!E79","v":0},"C"]
[null,null,"u",{"$f":"1.3391*10^-8*D82^2-1.0818*10^-6*D82+3.7125*10^-5","v":3.7125000000000001E-5},"lb-sec/ft2 @ 40F"]
[]
[null,"Controller Setting (%)",null,"RPM (R) ",{"$f":"\"G @ \"&D82&\" C\"","v":"G @ 0 C"}]
[null,"Min",0,0,{"$f":"IF($D$81=\"\",\"\",(($D$78*$D$79*(0.75*PI()*$D$80*D86/60)^3)/($D$83*$D$81))^0.5)","v":""}]
[null,null,{"$f":"IF($C$23=\"\",\"\",(($C$23-$C$13)/10+C86))","v":0.1},{"$f":"IF($D$96=\"\",\"\",(($D$96-$D$86)/10+D86))","v":""},{"$f":"IF($D$81=\"\",\"\",(($D$78*$D$79*(0.75*PI()*$D$80*D87/60)^3)/($D$83*$D$81))^0.5)","v":""}]
[null,null,0.2,{"$f":"IF($D$96=\"\",\"\",(($D$96-$D$86)/10+D87))","v":""},""]
[null,null,0.30000000000000004,"",""]
[null,null,0.4,"",""]
[null,null,0.5,"",""]
[null,null,0.6,"",""]
[null,null,0.7,"",""]
[null,null,0.79999999999999993,"",""]
[null,null,0.89999999999999991,"",""]
[null,"Max",1,null,""]
[null,"Actual",null,{"$f":"IF(OR(C97=\"\",D96=\"\"),\"\",IF(C97=C86,D86,(D96-D86)/((C96-C86)/(C97-C86))+D86))","v":""},""]

{"sheet":"BeamMixHELP","index":13,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,"Calculation of Velocity Gradient (G) for Walking Beam Mixers"]
[]
[]
[null,null,"Parameters","Input","Units","NOTE:"]
[null,null,"Coefficient of Drag (Cd)",3,null,"Input current water temperature in the DataEntry screen - the"]
[null,null,"Area of Paddles (A)",null,"ft2","velocity gradient calculation requires a current value to be accurate."]
[null,null,"Paddle Stroke Length (L)",null,"ft"]
[null,null,"Volume of basin (V)",null,"ft3"]
[null,null,"Water Temperature",{"$f":"DataEntry!E6","v":0},"C"]
[null,null,"u",{"$f":"1.3391*10^-8*D9^2-1.0818*10^-6*D9+3.7125*10^-5","v":3.7125000000000001E-5},"lb-sec/ft2 @ 40F"]
[]
[null,null,"Controller Setting (%)","RPM (R)",{"$f":"\"G @ \"&D9&\" C\"","v":"G @ 0 C"}]
[null,"Min",0,null,{"$f":"IF($D$8=\"\",\"\",((12.74*$D$5*$D$6*$D$7^3*(D13/60)^3)/($D$10*$D$8))^0.5)","v":""}]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C13))","v":0.1},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D13))","v":""},{"$f":"IF($D$8=\"\",\"\",((12.74*$D$5*$D$6*$D$7^3*(D14/60)^3)/($D$10*$D$8))^0.5)","v":""}]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C14))","v":0.2},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D14))","v":""},""]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C15))","v":0.30000000000000004},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D15))","v":""},""]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C16))","v":0.4},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D16))","v":""},""]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C17))","v":0.5},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D17))","v":""},""]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C18))","v":0.6},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D18))","v":""},""]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C19))","v":0.7},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D19))","v":""},""]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C20))","v":0.79999999999999993},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D20))","v":""},""]
[null,null,{"$f":"IF($C23=0,\"\",(($C$23-$C$13)/10+C21))","v":0.89999999999999991},{"$f":"IF($D23=0,\"\",(($D$23-$D$13)/10+D21))","v":""},""]
[null,"Max",1,null,""]
[null,"Actual",null,{"$f":"IF(OR(C24=\"\",D23=\"\"),\"\",IF(C24=C13,D13,(D23-D13)/((C23-C13)/(C24-C13))+D13))","v":""},{"$f":"IF(D8=\"\",\"\",IF(C24<C13,\"Error\",((12.74*$D$5*$D$6*$D$7^3*(D24/60)^3)/($D$10*$D$8))^0.5))","v":""}]
[]
[null,null,"Source:  Mixing in Coagulation and Flocculation, AWWARF 1991"]
[]
[null,"NOTE:"]
[null,"You will need to enter the data for each walking-beam mixer"]
[null,"and then tranfer the resulting G value to the appropriate"]
[null,"box on the JarSettingsHELP screen. For example, "]
[null,"if the plant has three-stage flocculation, the table will"]
[null,"need to be filled out once for each stage."]

{"sheet":"Database","index":14,"n_rows":10,"n_cols":97,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Date &",null,null,null,null,null,null,null,null,null,null,null,null,"Current","Other","Current Dose","Other","Current Dose",null,null,null,"Rapid Mix","Rapid Mix","Rapid Mix","Rapid Mix","Floc","Floc","Floc","Floc","Floc","Floc",null,"Stock Solution Concentration",null,null,"Raw Water","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 1","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 2","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 3","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 4","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 5","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6","Jar 6"]
["Sample No.",null,"Plant/Train","Water","Test","Test","Raw","Water","Water","Raw","Raw","Raw","Coagulant","Dose","Chemical 1","Other","Chemical 2","Other","Settled","IFE","Finished","Speed","Time","Speed","Time","Stage 1","Stage 1","Stage 2","Stage 2","Stage 3","Stage 3","Settle","Coagulant","Other","Other","Added to","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to Floc","Floc","Settled","Settled","Filtered","Settled","Settled","Coagulant","Other Chem 1","Other Chem 2","Time to","Floc","Settled","Settled","Filtered","Settled","Settled","Last"]
[43678,"Date","Name","Source","No.","Time","Turbidity","Temperature","Flow","pH","TOC","Alkalinity","Name","Coagulant","Name","Chemical 1","Name","Chemical 2","Turbidity","Turbidity","TOC","#1","#1","#2","#2","Speed","Time","Speed","Time","Speed","Time","Time",null,"Chemical 1","Chemical 2","Jars","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Formation","Size","Turb","pH","Turb","TOC","UV absorb","Dose","Dose","Dose","Floc","Size","Turb","pH","Turb","TOC","UV absorb","Column"]
["#","m/d/y",null,null,"#","hr:min","NTU","C","MGD","units","mg/L","mg/L",null,null,null,null,null,null,null,null,null,"RPM","min","RPM","min","RPM","min","RPM","min","RPM","min","min","%","%","%","mL","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1","mg/L","mg/L","mg/L","min","mm","NTU","units","NTU","mg/L","cm-1"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97]
[37044.01,"2001-06-02","Example","Wilson Lake",1,"09:00:00",6,15,7,7.4,4,65,"Alum",20,"Cat Floc",1,"Nalco 8109",0.05,2,0.15,2.2000000000000002,100,60,null,null,40,15,30,15,15,15,10,null,null,null,null,10,2.5,0.05,4,0.5,4,7.3,0.15,3.8,7.0000000000000007E-2,20,3,0.1,3,0.5,3.8,7.2,0.14000000000000001,3.7,6.5000000000000002E-2,30,3.5,0.15,2,1,3.5,7.1,0.13,3.5,0.06,40,4,0.2,1,2,3,7,0.12,3.3,5.5E-2,50,4.5,0.25,1,2,2.8,6.9,0.1,3.2,0.05,60,5,0.3,1,2,3.5,6.8,0.14000000000000001,3,0.04]
[37559.01,"2002-10-30","Thibodaux WTP","Bayou Lafourche",1,"02:00:00",53,23.7,1.44,7,7.7,72,"Alum",null,null,null,null,null,null,null,null,5,100,null,null,40,25,null,null,null,null,10,2,null,null,2000,null,null,null,null,null,47.1,6.85,null,null,null,20,null,null,10,null,45.8,6.85,null,null,null,40,null,null,2,null,14.4,6.75,null,null,null,60,null,null,2,null,1.38,6.67,null,null,null,80,null,null,2,null,1.74,6.57,null,null,null,100,null,null,2,null,2.06,6.49]
[37685.01,"2003-03-05","Winchester WTP","Kentucky River",1,"15:00:00",9.9,6,2.5,7.7,null,122,"Thermafloc",null,null,null,null,null,null,null,null,80,100,null,null,52,14,15,14,null,null,15,2,null,null,2000,10,null,null,null,null,10.199999999999999,7.35,null,null,7.5499999999999998E-2,20,null,null,null,null,4.2,7.15,null,null,6.4000000000000001E-2,30,null,null,null,null,3,7.19,null,null,5.8000000000000003E-2,40,null,null,null,null,3.2,7.16,null,null,5.2999999999999999E-2,50,null,null,null,null,0.8,7.29,null,null,5.1999999999999998E-2,60,null,null,null,null,1.45,7.12,null,null,4.4499999999999998E-2]
[38477.01,"2005-05-05","Algiers WTP","Mississippi River",1,"00:00:00",null,20,10,null,null,null,"Ferric Sulfate",7.25,"Magnafloc",6.9,"Lime",55,null,null,null,47,33,118,2,45,44,null,null,null,null,null,0.15,0.15,1.5,1500,null,6.9,55,null,null,null,null,null,null,null,3,6.9,55,null,null,null,null,null,null,null,6,6.9,55,null,null,null,null,null,null,null,7.25,6.9,55,null,null,null,null,null,null,null,9,6.9,55,null,null,null,null,null,null,null,12,6.9,55]
[43678,"2019-08-01","Ottawa, KS",null,null,"00:00:00",6.5,26.2,3.7440000000000002,7.7]